package c.x.jy.dao.dao;

import c.x.jy.dao.dto.AgreeArticleEntityDto;
import c.x.jy.dao.entity.AgreeArticleEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * 
 * 
 * @author amwhyh
 * @email xxx@xx.com
 * @date 2021-06-15 12:01:28
 */
@Mapper
public interface AgreeArticleDao extends BaseMapper<AgreeArticleEntity> {
    @Select("select a.*,ad.content from t_agree_article a LEFT JOIN t_agree_article_data ad on ad.id=a.article_data_id where a.code='${code}' limit 1")
    AgreeArticleEntityDto getByCode(String code);
}

